oracle dba fundamentals

Test environment: win2003 + oracle10gr2 Set environment variables:Set ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1Set java_home = % ORACLE_HOME % \ JDKSet Path = % java_home % \ bin; % PATH % Go to the ISQLPLUS directory:Cd % ORACLE_HOME % \ Solaris \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS Enter the jazn command environment:Java-djava. security. properties = % ORACLE_HOME %/sqlplus/admin/iplus/provider-jar % ORACLE_HOME %/Solaris/

After reading the manuscript "Oracle DBA manual" sent by eygle, I felt that the writing idea of this book was quite new. With the improvement of Database Technology automation, DBA's work value has begun to expand to a greater level. Therefore, sharing the experiences of some Pathfinder has become particularly valuable. Exposing its thinking process is a major feature of the technology circle in the web era

Tags: Wind brother Oracle Oracle Training Oracle Database tutorial Oracle video wind Brother Oracle TutorialsBecause it is a "top secret leaked" information, to prevent the investigation, the need for the small partners to quickly download the attached courseware document.Be

Oracle Oracle DAB two day crash course The purpose of this course is to supplement the DBA's two-day quick (2 days dba) manual. In this course, you will learn more about the tasks outlined in the DBA's two-day quick (2 days dba) manual, and include step-by-step instructions. To view the information for this course

Oracle Pen questions Oracle DBA face questions and answers (foreign companies)Oracle Database Pen Test DBAOracle Interview Pen test for international large companiesOracle Database DBA Interview Questions1. How many memory layers are in the shared pool?2. How did you find th

Tags: adding to Oinstall and DBA user groupsUsermod-g oinstall-g dba-d/home/oracle Oracle-G is the Oinstall group for the specified user's primary group-G is the DBA group for the specified user's secondary group-D for the specified user's home directorystatement is defined

Why is it so difficult to find a good Oracle DBA? This is not only the pain of many CIOs, but also the problem that many IT directors cannot solve. But where do so many people who have obtained OCP certification from ORACLE training courses go? Tom is a database administrator with An OCP license and a certain understanding of the database architecture and operat

Differences between sys and system users 1) The most important difference is that the importance of stored data is different. Base tables and views of all ORACLE data dictionaries in SYS are stored in SYS users. These base tables and views are crucial for Oracle operation and are maintained by the database, no user can change it manually. Sys users have the role or permissions such as

With the rapid development of Oracle technology and the market, the number of people working in Oracle DBA is getting bigger and bigger. I can see from some posts that I often post on forums and communities, many people are eager to work in this field now or in the future, and the market demand is also very large, but it is not hard to see that each company has h

tuning rules that every Oracle DBA should follow Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most effective ways to do this is through

Oracle users have relatively large permissions. Therefore, you may need to use non-oracle users to manage related databases. In particular, it is necessary for multiple individuals to add different users to the system or database, and then add these users to the dba group. These users can also set different environment variables based on their preferences. This a

Oracle Pen questions Oracle DBA face questions and answers (foreign companies)Oracle Database Pen Test DBAOracle Interview Pen test for international large companiesOracle Database DBA Interview Questions1. How many memory layers are in the shared pool?2. How did you find th

After the Oracle 10g Database is installed, the web page is installed by default to manage the access path of Oracle. Two isqlplus websites are available. After the Oracle 10g Database is installed, the web page is installed by default to manage the access path of Oracle, including two isqlplus websites. This is becaus

The daily work and responsibilities of DBAs in Oracle --- [1] The following summary is a summary written in "Deep Oracle", which corresponds to the amount of funds learned. 1. Let's take a look at Oracle's learning route: 2. learning basics: I have learned basic Oracle knowledge and have a general understanding of Oracle